
Create Procedure [MetodosNovos] 
	@revisao_anterior int,
	@revisao_ATUAL int
	as
	Begin
	Select ROW_NUMBER() Over(ORDER BY Type, Member) as i , @revisao_anterior as ant, @revisao_ATUAL as post, recente.[NameSpace], recente.[Type], recente.Member, recente.Maintainability,
	recente.CyclomaticComplexity, recente.DepthOfInheritance,
	recente.ClassCoupling, recente.LinesOfCode From
	(select * from CodeMetric Where Revision = @revisao_ATUAL And Project in ('Fgv.SigaDois.Negoc (Debug)', 'Fgv.SigaDois.ConveniadoOnline.Servicos (Debug)')) recente
	Where recente.[Scope] = 'Member' And
	Not Exists
	(select 1 from CodeMetric as antiga Where antiga.Revision = @revisao_anterior And antiga.Project in ('Fgv.SigaDois.Negoc (Debug)', 'Fgv.SigaDois.ConveniadoOnline.Servicos (Debug)') And recente.[Type] = antiga.[Type] And recente.Project = antiga.Project And recente.Member = antiga.Member And recente.Scope = antiga.Scope )
	And recente.[Type] not in ('BaseServico', 'BaseNegoc')
	And recente.[Member] not like '%.Get()%' And recente.[Member] not like '%.Set(%'
	And recente.[Member] not like '%New()%' And recente.[Type] not like 'I%' Order By 2, 4, 5
	End

GO


